The pivot transformation includes the 透視轉(zhuǎn)換包括
Configuring the pivot transformation 配置透視轉(zhuǎn)換
The pivot transformation uses the properties on its input and output columns to define the pivot operation 透視轉(zhuǎn)換使用其輸入列和輸出列的屬性來定義透視操作。
By pivoting the data set on the product column , the pivot transformation can output a data set with a single row per customer 此時(shí),如果對(duì)產(chǎn)品列透視數(shù)據(jù)集,透視轉(zhuǎn)換可以輸出每個(gè)客戶只有一行的數(shù)據(jù)集。
The pivot transformation makes a normalized data set into a less normalized but more compact version by pivoting the input data on a column value . for example , a normalized 通過透視列值的輸入數(shù)據(jù),透視轉(zhuǎn)換將規(guī)范化的數(shù)據(jù)集轉(zhuǎn)變成規(guī)范化程度稍低、但更為簡潔的版本。
If the data is not sorted , the pivot transformation might generate multiple records for each value in the set key , which is the column that defines set membership 如果數(shù)據(jù)未經(jīng)排序,那么透視轉(zhuǎn)換就可能為設(shè)置鍵(即定義集成員關(guān)系的列)中的每個(gè)值生成多個(gè)記錄。例如,如果對(duì)